using Lamex.Base.Framework.BaseAbs; 
using Lamex.Base.Framework.BaseDal; 
using  Lamex.mIE.Interface; 
using  Lamex.mIE.Model;
using System.Data; 
namespace Lamex.mIE.DalServer 
{
 public class IE_Part_TaskList : BaseDalSQL<IE_Part_TaskListInfo>,IIE_Part_TaskList
  {
      public DataSet GetDataSet()
      {
          string sql = @"SELECT [PROD_CATEGORY]
      ,[FILE_NO]
      ,[DWG_NO]
      ,T.[PART_NO]
      ,M.[CN_DESC]
      ,M.[EN_DESC]
      ,[REF_MAT]
      ,[REF_DWG]
      ,[IMPORT_TIME]
      ,[IMPORT_USER]
      ,[CURRENT_USERS]
      ,[ROUTING_FLAG]
      ,[PARM_FLAG]
      ,[FEAT_FLAG]
      ,[REF_FLAG]
      ,[CAL_FLAG]
      ,[UPLOAD_FLAG]
  FROM [LamexMESManager].[dbo].[IE_Part_TaskList] T
  LEFT jOIN [dbo].[IE_Part_MasterData] M ON T.PART_NO=M.PART_NO
  where  ISNULL(T.UPLOAD_FLAG,'')!='1'  order by IMPORT_TIME desc";
          return base.GetDataSetBySql(sql);
      }
      public DataTable GetProductItem()
      {
          //string sql = @"select distinct PROD_CATEGORY FROM [LamexMESManager].[dbo].[IE_Part_TaskList]";
          string sql = @" select FIELD_VALUE_OPTION FROM [LamexMESManager].[dbo].[Sys_ControlValueOption] where FIELD_NAME='PRODUCT_TYPE'";
          return base.GetDataTableBySql(sql);
      }
  }
};
